Function Crosstabs
Both Standard and a Multi-dimensional crosstabs can also be a functional cross tabulation. A functional cross tabulation allows the result of a mathematical function to be displayed, rather than a count.
Normally, the numbers in the cells of the result table are COUNTS of rows in the resolution table. A functional cross tabulation allows the user to display the result of a mathematical function, rather than a count.
For a functional cross tabulation to work a function needs to be identified and also a field upon which this will be applied. The functions are:
- Count
- Sum
- Mean
- Min
- Max
- Standard Deviation
- Sample Standard Deviation
The field must be numeric, and must either come from the same table as the crosstab, or from a table on the ONE side of a ONE to MANY link:
| Note: | if it is necessary to use a field from the MANY side of the join, the field can be aggregated to the crosstab table level and then applied as the function column. |
Example of a Function Crosstab
Using a Function crosstab, rather than just displaying the counts of record, you could also display the average income. In the example below you can see that for Directors over 65, the average income is £56,914.50.
| RESOLUTION TABLE | [DEMO].[CUSTOMER] |
| Y-AXIS | [DEMO].[CUSTOMER].[OCCUPATION] |
| X-AXIS | [DEMO].[CUSTOMER].[AGEBAND] |
| FUNCTION | MEAN |
| EVALUATION COLUMN | [DEMO].[CUSTOMER].[INCOME] |
